﻿using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using Spread.Common.Features.Sample;
using GrapeCity.Win.Spread.InputMan.CellType;
using Spread.Common.DataStore;
using FarPoint.Win.Spread;
using GrapeCity.Win.Spread.InputMan.CellType.Fields;
namespace Spread.CellTypes.Features
{
    public partial class GCInputManDemo : BaseSampleControl
    {
        public GCInputManDemo()
        {
            InitializeComponent();
            Name = "New MESCIUS InputMan";
            spread.ActiveSheet = spread.Sheets[0];

            //Initialize Sheets
            InitTextBoxSheetView();
            InitComboBoxSheetView();
            InitDateTimeSheetView();
            InitNumberSheetView();
            InitMaskCellSheetView();
            InitCharMaskCellSheetView();
            InitTimeSpanCellSheetView();
        }
        private void InitTextBoxSheetView()
        {
            //Initialize Data
            sViewTextBox.DataSource = new DataService().AccessDataSource.GetNWINDData("Customers");

            sViewTextBox.Rows.Default.Height = 25;
            sViewTextBox.Columns[1].Font = new Font(FontFamily.GenericMonospace, 8, FontStyle.Italic);

            AutoCompleteStringCollection autoCompleteStringCollection = new AutoCompleteStringCollection();
            string[] suggestionList = ("Benjamin,Bruce,Cheryl,Daniel,Dave,Eric,Hana,Harol," +
                                "Henry,Jane,Jessica,John,Julia,Kathy,Lance,Laura,Mark,Marry," +
                                "Meggie,Mike,Naomi,Paul,Peter,Roger,Rose,Ruth,Ryan,Shirley," +
                                "Tan,Thomas,Tony, Varun,$1234, VND1234, 12345 %,13 %," +
                                "02/19/1991,Sunday, August 08, 2007,Saturday, March 09, 1997," +
                                "February,0901234567,0953336650").Split(',');

            autoCompleteStringCollection.AddRange(suggestionList);

            var cTypeAutoComplete = new GcTextBoxCellType()
            {
                AutoCompleteMode = AutoCompleteMode.SuggestAppend,
                AutoCompleteSource = AutoCompleteSource.CustomSource,
                AutoCompleteCustomSource = autoCompleteStringCollection,
            };

            sViewTextBox.Columns[1].CellType = cTypeAutoComplete;
            sViewTextBox.ColumnHeader.Cells[0, 1].Note = "AutoComplete Column";
            sViewTextBox.ColumnHeader.Cells[0, 1].NoteStyle = NoteStyle.StickyNote;
        }
        private void InitComboBoxSheetView()
        {
            sViewComboBox.DataSource = new DataService().AccessDataSource.GetNWINDData("Orders");

            sViewComboBox.DataAutoSizeColumns = false;
            sViewComboBox.Columns.Default.Width = 90;
            sViewComboBox.Rows.Default.Height = 25;

            DataSet dataSet = new DataService().AccessDataSource.GetNWINDData("Order Details");

            var cTypeComboBox = new GcComboBoxCellType()
            {
                DataSource = dataSet,
                DataMember = dataSet.Tables[0].TableName
            };
            sViewComboBox.Columns[0].CellType = cTypeComboBox;

        }
        private void InitDateTimeSheetView()
        {
            var cTypeDateTime = new GcDateTimeCellType();
            cTypeDateTime.DropDown.ShowShadow = true;
            cTypeDateTime.Fields.Clear();

            cTypeDateTime.Fields.AddRange(new DateFieldInfo[]
            {
                new DateYearFieldInfo(),
                new DateLiteralFieldInfo() { Text = "-" },
                new DateMonthFieldInfo(),
                new DateLiteralFieldInfo() { Text = "-" },
                new DateDayFieldInfo(),
                new DateLiteralFieldInfo() { Text = " " },
                new DateHourFieldInfo(),
                new DateLiteralFieldInfo() { Text = ":" },
                new DateMinuteFieldInfo(),
                new DateLiteralFieldInfo() { Text = ":" },
                new DateSecondFieldInfo(),
            });
            sViewDateTime.Columns[3].CellType = cTypeDateTime;

            var maskCell = new GcDateTimeCellType();
            maskCell.DropDown.ShowShadow = true;
            maskCell.PromptChar = '#';
            sViewDateTime.Columns[4].CellType = maskCell;

            sViewDateTime.AutoGenerateColumns = false;

            sViewDateTime.DataSource = new DataService().AccessDataSource.GetNWINDData("Orders");
            sViewDateTime.BindDataColumn(0, "OrderID");
            sViewDateTime.BindDataColumn(1, "CustomerID");
            sViewDateTime.BindDataColumn(2, "EmployeeID");
            sViewDateTime.BindDataColumn(3, "OrderDate");
            sViewDateTime.Columns.Add(4, 1);
            sViewDateTime.Columns[4].Label = "Required";

            sViewDateTime.DataAutoSizeColumns = false;
            sViewDateTime.Columns.Default.Width = 90;
            sViewDateTime.Rows.Default.Height = 25;

            for (int column = 3; column <= 4; column++)
            {
                sViewDateTime.Columns[column].Width = 150;
            }
        }
        private void InitNumberSheetView()
        {
            sViewNumber.AutoGenerateColumns = false;
            sViewNumber.DataAutoSizeColumns = false;
            sViewNumber.Columns.Default.Width = 110;
            sViewNumber.Rows.Default.Height = 25;

            var gcNumberCell = new GcNumberCellType();
            gcNumberCell.DropDown.ShowShadow = true;
            gcNumberCell.Fields.IntegerPart.MinDigits = 2;

            var gcNullText = new GcNumberCellType();
            gcNullText.DropDown.ShowShadow = true;
            gcNullText.Fields.SignSuffix.NegativePattern = "";
            gcNullText.AlternateText.Null.Text = "Null Value";
            gcNullText.AlternateText.Zero.Text = "Zero";
            gcNullText.Fields.IntegerPart.MinDigits = 2;

            sViewNumber.DataSource = new DataService().AccessDataSource.GetNWINDData("Products");

            sViewNumber.BindDataColumn(0, "ProductID");
            sViewNumber.BindDataColumn(1, "ProductName");
            sViewNumber.BindDataColumn(2, "UnitsInStock");
            sViewNumber.BindDataColumn(3, "UnitsOnOrder");
            sViewNumber.BindDataColumn(4, "ReorderLevel");

            sViewNumber.Columns[2].CellType = gcNumberCell;
            sViewNumber.Columns[3].CellType = gcNullText;
        }
        private void InitMaskCellSheetView()
        {
            sViewMask.DataAutoSizeColumns = false;
            sViewMask.Columns.Default.Width = 90;
            sViewMask.Rows.Default.Height = 25;
            for (int column = 1; column <= 3; column++)
            {
                sViewMask.Columns[column].Width = 150;
            }

            var maskPattern = new GcMaskCellType();
            maskPattern.Fields.AddRange(@"℡ \D{3}-\D{4}-\D{4}");
            maskPattern.RecommendedValue = "17155557788";
            maskPattern.ShowRecommendedValue = true;

            sViewMask.AutoGenerateColumns = false;
                  sViewMask.DataSource = new DataService().AccessDataSource.GetNWINDData("Customers");
            sViewMask.BindDataColumn(0, "CustomerID");
            sViewMask.BindDataColumn(1, "ContactName");
            sViewMask.BindDataColumn(2, "ContactTitle");
            sViewMask.BindDataColumn(3, "Address");
            sViewMask.BindDataColumn(4, "City");
            sViewMask.Columns[5].Label = "Phone";

            sViewMask.Columns[5].CellType = maskPattern;
            sViewMask.Columns[5].Width = 110;
        }
        private void InitCharMaskCellSheetView()
        {
            sViewCharMask.DataAutoSizeColumns = false;
            sViewCharMask.Columns.Default.Width = 90;
            sViewCharMask.Rows.Default.Height = 25;

            var gcCharMaskCell = new GcCharMaskCellType();

            InputBoxInfo inputBoxMaskCell = new InputBoxInfo()
            {
                AutoSize = false,
                Size = new Size(17, 20),
            };
            inputBoxMaskCell.Border.SetAllLines(Color.Black, LineStyle.Single);

            var charBoxMaskCell = gcCharMaskCell.CharBoxes;
            charBoxMaskCell.Clear();
            charBoxMaskCell.Add(inputBoxMaskCell, 5);

            sViewCharMask.DataSource = new DataService().AccessDataSource.GetNWINDData("Customers");
            sViewCharMask.Columns[0].CellType = gcCharMaskCell;
            sViewCharMask.Columns[0].Font = new Font(FontFamily.GenericSansSerif, 8, FontStyle.Italic);
        }
        private void InitTimeSpanCellSheetView()
        {
            sViewTimeSpan.AutoGenerateColumns = false;
            sViewTimeSpan.DataAutoSizeColumns = false;
            sViewTimeSpan.Columns.Default.Width = 90;
            sViewTimeSpan.Rows.Default.Height = 25;

            var gcTimeSpanCell = new GcTimeSpanCellType()
            {
              ShowRecommendedValue = true,
            };
            gcTimeSpanCell.Fields.Clear();
            gcTimeSpanCell.Fields.AddRange(new TimeSpanFieldInfo[]
            {
              new TimeSpanSignFieldInfo("", "-"),
              new TimeSpanDayFieldInfo(2),
              new TimeSpanLiteralFieldInfo(":"),
              new TimeSpanHourFieldInfo(2),
              new TimeSpanLiteralFieldInfo(":"),
              new TimeSpanMinuteFieldInfo(2),
              new TimeSpanLiteralFieldInfo(":"),
              new TimeSpanSecondFieldInfo(2),
            });

            gcTimeSpanCell.DisplayFields.AddRange(new TimeSpanDisplayFieldInfo[]
            {
                new TimeSpanSignDisplayFieldInfo("", "-"),
                new TimeSpanDayDisplayFieldInfo(2),
                new TimeSpanLiteralDisplayFieldInfo(":"),
                new TimeSpanHourDisplayFieldInfo(2),
                new TimeSpanLiteralDisplayFieldInfo(":"),
                new TimeSpanMinuteDisplayFieldInfo(2),
                new TimeSpanLiteralDisplayFieldInfo(":"),
                new TimeSpanSecondDisplayFieldInfo(2),
            });
            sViewTimeSpan.DataSource = new DataService().AccessDataSource.GetNWINDData("Orders");

            sViewTimeSpan.BindDataColumn(0, "OrderID");
            sViewTimeSpan.BindDataColumn(1, "ShipVia");
            sViewTimeSpan.BindDataColumn(2, "ShipCountry");
            sViewTimeSpan.BindDataColumn(3, "OrderDate");
            sViewTimeSpan.BindDataColumn(4, "RequiredDate");
            sViewTimeSpan.ColumnCount++;
            sViewTimeSpan.Columns[5].Label = "Buffer";
            sViewTimeSpan.Columns[5].CellType = gcTimeSpanCell;
            for (int r = 0; r < sViewTimeSpan.RowCount; r++)
                sViewTimeSpan.Cells[r, 5].Value = (DateTime)sViewTimeSpan.Cells[r, 4].Value - (DateTime)sViewTimeSpan.Cells[r, 3].Value;
        }
        private string[] GetMappedData(string selectColumn, string orderColumn, string tableName)
        {
            var data = new DataService().AccessDataSource.GetNWINDDataComplete(string.Format("SELECT DISTINCT {0},{2} FROM `{1}` ORDER BY {2} ASC", selectColumn, tableName, orderColumn));
            string dataItem = "";
            foreach (DataRow item in data.Tables[0].Rows)
            {
                dataItem += item[0] + "|";
            }
            return dataItem.TrimEnd('|').Split('|');
        }
    }
}


//
//GCInputManDemo.Designer.cs
//


namespace Spread.CellTypes.Features
{
    partial class GCInputManDemo
    {
        /// <summary> 
        /// Required designer variable.
        /// </summary>
        private System.ComponentModel.IContainer components = null;

        /// <summary> 
        /// Clean up any resources being used.
        /// </summary>
        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
        protected override void Dispose(bool disposing)
        {
            if (disposing && (components != null))
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }

        #region Component Designer generated code

        /// <summary> 
        /// Required method for Designer support - do not modify 
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            this.spread = new FarPoint.Win.Spread.FpSpread(FarPoint.Win.Spread.LegacyBehaviors.None);
            this.sViewCharMask = new FarPoint.Win.Spread.SheetView();
            this.sViewComboBox = new FarPoint.Win.Spread.SheetView();
            this.sViewDateTime = new FarPoint.Win.Spread.SheetView();
            this.sViewMask = new FarPoint.Win.Spread.SheetView();
            this.sViewNumber = new FarPoint.Win.Spread.SheetView();
            this.sViewTextBox = new FarPoint.Win.Spread.SheetView();
            this.sViewTimeSpan = new FarPoint.Win.Spread.SheetView();
            this.pnlMain.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.spread)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.sViewCharMask)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.sViewComboBox)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.sViewDateTime)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.sViewMask)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.sViewNumber)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.sViewTextBox)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.sViewTimeSpan)).BeginInit();
            this.SuspendLayout();
            // 
            // pnlMain
            // 
            this.pnlMain.Controls.Add(this.spread);
            // 
            // spread
            // 
            this.spread.AccessibleDescription = "spread, FieldsEditorControl, Row 0, Column 0";
            this.spread.Dock = System.Windows.Forms.DockStyle.Fill;
            this.spread.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
            this.spread.Location = new System.Drawing.Point(0, 0);
            this.spread.Name = "spread";
            this.spread.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] {
            this.sViewCharMask,
            this.sViewComboBox,
            this.sViewDateTime,
            this.sViewMask,
            this.sViewNumber,
            this.sViewTextBox,
            this.sViewTimeSpan});
            this.spread.Size = new System.Drawing.Size(477, 487);
            this.spread.TabIndex = 0;
            this.spread.ActiveSheetIndex = 3;
            // 
            // gcCharMask
            // 
            this.sViewCharMask.Reset();
            this.sViewCharMask.SheetName = "GCCharMask";
            // Formulas and custom names must be loaded with R1C1 reference style
            this.sViewCharMask.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
            this.sViewCharMask.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
            // 
            // gcComboBox
            // 
            this.sViewComboBox.Reset();
            this.sViewComboBox.SheetName = "GCComboBox";
            // Formulas and custom names must be loaded with R1C1 reference style
            this.sViewComboBox.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
            this.sViewComboBox.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
            // 
            // gcDateTime
            // 
            this.sViewDateTime.Reset();
            this.sViewDateTime.SheetName = "GCDateTime";
            // Formulas and custom names must be loaded with R1C1 reference style
            this.sViewDateTime.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
            this.sViewDateTime.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
            // 
            // gcMask
            // 
            this.sViewMask.Reset();
            this.sViewMask.SheetName = "GCMask";
            // Formulas and custom names must be loaded with R1C1 reference style
            this.sViewMask.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
            this.sViewMask.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
            // 
            // gcNumber
            // 
            this.sViewNumber.Reset();
            this.sViewNumber.SheetName = "GCNumber";
            // Formulas and custom names must be loaded with R1C1 reference style
            this.sViewNumber.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
            this.sViewNumber.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
            // 
            // gcTextBox
            // 
            this.sViewTextBox.Reset();
            this.sViewTextBox.SheetName = "GCTextBox";
            // Formulas and custom names must be loaded with R1C1 reference style
            this.sViewTextBox.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
            this.sViewTextBox.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
            // 
            // gcTimeSpan
            // 
            this.sViewTimeSpan.Reset();
            this.sViewTimeSpan.SheetName = "GCTimeSpan";
            // Formulas and custom names must be loaded with R1C1 reference style
            this.sViewTimeSpan.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
            this.sViewTimeSpan.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
            // 
            // GCInputManCellType
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.Name = "GCInputManCellType";
            this.pnlMain.ResumeLayout(false);
            ((System.ComponentModel.ISupportInitialize)(this.spread)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.sViewCharMask)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.sViewComboBox)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.sViewDateTime)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.sViewMask)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.sViewNumber)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.sViewTextBox)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.sViewTimeSpan)).EndInit();
            this.ResumeLayout(false);

        }

        #endregion

        private FarPoint.Win.Spread.FpSpread spread;
        private FarPoint.Win.Spread.SheetView sViewCharMask;
        private FarPoint.Win.Spread.SheetView sViewComboBox;
        private FarPoint.Win.Spread.SheetView sViewDateTime;
        private FarPoint.Win.Spread.SheetView sViewMask;
        private FarPoint.Win.Spread.SheetView sViewNumber;
        private FarPoint.Win.Spread.SheetView sViewTextBox;
        private FarPoint.Win.Spread.SheetView sViewTimeSpan;
    }
}
